import openpyxl

# 打开工作簿
workbook = openpyxl.load_workbook('景区天气.xlsx')
# 选择要操作的工作表
sheet = workbook['景区天气']
# 读取二维列表
lst = []
for row in sheet.rows:
    lst_c = [] # 存储单元格数据
    for cell in row:
       lst_c.append(cell.value)
    lst.append(lst_c)

for item in lst:
    print(item)